/*
 Navicat Premium Data Transfer

 Source Server         : 本地mysql
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : backend-server

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 12/04/2021 11:17:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for system_menu
-- ----------------------------
DROP TABLE IF EXISTS `system_menu`;
CREATE TABLE `system_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` int(11) DEFAULT NULL,
  `update_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `component` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `parent_id` bigint(20) DEFAULT NULL,
  `path` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `sort_order` decimal(10,2) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `enable` tinyint(1) DEFAULT NULL,
  `button_role` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `button_role_prefix` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of system_menu
-- ----------------------------
BEGIN;
INSERT INTO `system_menu` VALUES (1, 'admin', '2020-07-11 16:20:52', 0, 'admin', '2020-08-18 22:20:06', 'Layout', '系统管理', 'edit', '系统管理', NULL, NULL, '/system', 20.00, 0, 0, 1, NULL, NULL);
INSERT INTO `system_menu` VALUES (2, 'admin', '2020-07-11 16:22:05', 0, 'admin', '2020-07-13 03:28:52', 'system/menu', '菜单管理', 'edit', '菜单管理', NULL, 1, 'menu', 2.00, NULL, 0, 1, NULL, NULL);
INSERT INTO `system_menu` VALUES (3, NULL, '2020-07-11 03:43:03', 0, NULL, '2020-07-13 03:29:06', 'system/roles', NULL, 'edit', '角色管理', NULL, 1, 'roles', 3.00, NULL, 0, 1, NULL, NULL);
INSERT INTO `system_menu` VALUES (4, NULL, '2020-07-11 23:54:15', 0, NULL, '2020-07-14 01:42:55', '11', NULL, '111', '添加子菜单', NULL, 2, 'hhh', 11.00, NULL, 1, 1, '/addSubMenu', 'system/menu');
INSERT INTO `system_menu` VALUES (5, NULL, '2020-07-12 01:28:12', 0, NULL, '2021-04-12 10:22:51', 'Layout', NULL, 'edit', '用户管理', NULL, NULL, '/blog2', 1.00, NULL, 0, 1, '', '');
INSERT INTO `system_menu` VALUES (19, NULL, '2020-07-13 03:28:45', 0, NULL, '2020-07-13 03:28:45', 'system/user', NULL, 'edit', '用户管理', NULL, 1, 'user', 1.00, NULL, 0, 1, '', 'Layout');
INSERT INTO `system_menu` VALUES (20, NULL, '2020-07-13 22:55:57', 0, NULL, '2020-07-14 01:43:09', '', NULL, '', '添加一级菜单', NULL, 2, '', NULL, NULL, 1, 1, '/addFirstMenu', 'system/menu');
INSERT INTO `system_menu` VALUES (22, NULL, '2020-07-15 08:53:10', 0, NULL, '2020-07-15 08:53:10', '', NULL, '', '分配权限', NULL, 3, '', NULL, NULL, 1, 1, '/assignRoles', 'system/roles');
INSERT INTO `system_menu` VALUES (23, NULL, '2020-07-15 09:06:06', 0, NULL, '2020-07-15 09:06:06', '', NULL, '', '添加角色', NULL, 3, '', NULL, NULL, 1, 1, '/addRole', 'system/roles');
INSERT INTO `system_menu` VALUES (24, NULL, '2020-07-15 09:06:51', 0, NULL, '2020-07-15 09:06:51', '', NULL, '', '批量删除', NULL, 3, '', NULL, NULL, 1, 1, '/deleteBatch', 'system/roles');
INSERT INTO `system_menu` VALUES (25, NULL, '2020-07-15 09:08:17', 0, NULL, '2020-07-15 09:08:17', '', NULL, '', '编辑', NULL, 3, '', NULL, NULL, 1, 1, '/edit', 'system/roles');
INSERT INTO `system_menu` VALUES (26, NULL, '2020-07-15 09:08:25', 0, NULL, '2020-07-15 09:08:25', '', NULL, '', '删除', NULL, 3, '', NULL, NULL, 1, 1, '/delete', 'system/roles');
INSERT INTO `system_menu` VALUES (27, NULL, '2020-08-18 21:04:04', 0, NULL, '2021-04-12 10:23:00', 'blog2/bloglist', NULL, 'edit', '用户列表', NULL, 5, 'bloglist', 1.00, NULL, 0, 1, '', 'Layout');
INSERT INTO `system_menu` VALUES (28, NULL, '2020-08-18 22:02:36', 0, NULL, '2021-04-12 10:23:07', 'blog/blogtype', NULL, 'edit', '用户类型', NULL, 5, 'blogtype', 2.00, NULL, 0, 1, '', 'Layout');
INSERT INTO `system_menu` VALUES (30, NULL, '2020-08-18 22:07:52', 0, NULL, '2020-08-18 22:07:52', 'leave/leavelist', NULL, 'edit', '留言列表', NULL, 29, 'leavelist', 1.00, NULL, 0, 1, '', 'Layout');
INSERT INTO `system_menu` VALUES (31, NULL, '2020-08-18 22:09:36', 0, NULL, '2020-08-18 22:09:36', 'leave/leavecollect', NULL, 'edit', '留言统计', NULL, 29, 'leavecollect', 2.00, NULL, 0, 1, '', 'Layout');
INSERT INTO `system_menu` VALUES (32, NULL, '2020-08-18 22:10:21', 0, NULL, '2021-04-12 10:23:11', 'blog/blogcollect', NULL, 'edit', '用户统计', NULL, 5, 'blogcollect', 3.00, NULL, 0, 1, '', 'Layout');
INSERT INTO `system_menu` VALUES (34, NULL, '2020-08-18 22:11:45', 0, NULL, '2021-04-12 10:23:52', 'Layout', NULL, 'edit', '选课信息管理', NULL, NULL, 'plan', 2.00, NULL, 0, 1, '', '');
INSERT INTO `system_menu` VALUES (35, NULL, '2020-08-18 22:12:49', 0, NULL, '2021-04-12 10:24:34', 'plan/planlist', NULL, 'edit', '学生选课', NULL, 34, 'planlist', 1.00, NULL, 0, 1, '', 'Layout');
INSERT INTO `system_menu` VALUES (36, NULL, '2020-08-18 22:13:56', 0, NULL, '2021-04-12 10:24:44', 'plan/planexecuterecord', NULL, 'edit', '老师选课', NULL, 34, 'planexecuterecord', 1.00, NULL, 0, 1, '', 'Layout');
INSERT INTO `system_menu` VALUES (40, NULL, '2020-08-18 22:21:13', 0, NULL, '2020-08-18 22:21:13', 'publicno/attention', NULL, 'edit', '公众号关注列表', NULL, 39, 'attention', 1.00, NULL, 0, 1, '', 'Layout');
INSERT INTO `system_menu` VALUES (41, NULL, '2020-08-18 22:22:04', 0, NULL, '2020-08-18 22:22:04', 'publicno/news', NULL, 'edit', '消息列表', NULL, 39, 'news', 1.00, NULL, 0, 1, '', 'Layout');
INSERT INTO `system_menu` VALUES (43, NULL, '2020-08-18 22:24:36', 0, NULL, '2020-08-18 22:24:36', 'social/sociallist', NULL, 'edit', '第三方用户列表', NULL, 42, 'sociallist', 1.00, NULL, 0, 1, '', 'Layout');
COMMIT;

-- ----------------------------
-- Table structure for system_role
-- ----------------------------
DROP TABLE IF EXISTS `system_role`;
CREATE TABLE `system_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` int(11) DEFAULT NULL,
  `update_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `role_desc` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `role_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of system_role
-- ----------------------------
BEGIN;
INSERT INTO `system_role` VALUES (1, NULL, '2020-07-13 15:29:48', 0, NULL, '2020-07-13 15:29:58', '管理员权限，属于最高权限 所有的操作能力都拥有管理员权限，属于最高权限 所有的操作能力都拥有', 'admin');
INSERT INTO `system_role` VALUES (2, NULL, '2020-07-13 15:29:48', 0, NULL, '2020-07-13 15:29:58', '管理员权限，属于最高权限 所有的操作能力都拥有', 'editor');
COMMIT;

-- ----------------------------
-- Table structure for system_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `system_role_menu`;
CREATE TABLE `system_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` int(11) DEFAULT NULL,
  `update_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `menu_id` bigint(20) DEFAULT NULL,
  `role_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=210 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of system_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `system_role_menu` VALUES (121, NULL, '2020-08-13 06:57:37', 0, NULL, '2020-08-13 06:57:37', 5, 2);
INSERT INTO `system_role_menu` VALUES (122, NULL, '2020-08-13 06:57:37', 0, NULL, '2020-08-13 06:57:37', 1, 2);
INSERT INTO `system_role_menu` VALUES (123, NULL, '2020-08-13 06:57:37', 0, NULL, '2020-08-13 06:57:37', 19, 2);
INSERT INTO `system_role_menu` VALUES (124, NULL, '2020-08-13 06:57:37', 0, NULL, '2020-08-13 06:57:37', 2, 2);
INSERT INTO `system_role_menu` VALUES (182, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 5, 1);
INSERT INTO `system_role_menu` VALUES (183, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 27, 1);
INSERT INTO `system_role_menu` VALUES (184, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 28, 1);
INSERT INTO `system_role_menu` VALUES (185, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 32, 1);
INSERT INTO `system_role_menu` VALUES (186, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 34, 1);
INSERT INTO `system_role_menu` VALUES (187, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 35, 1);
INSERT INTO `system_role_menu` VALUES (188, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 36, 1);
INSERT INTO `system_role_menu` VALUES (189, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 38, 1);
INSERT INTO `system_role_menu` VALUES (190, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 29, 1);
INSERT INTO `system_role_menu` VALUES (191, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 30, 1);
INSERT INTO `system_role_menu` VALUES (192, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 31, 1);
INSERT INTO `system_role_menu` VALUES (193, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 37, 1);
INSERT INTO `system_role_menu` VALUES (194, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 39, 1);
INSERT INTO `system_role_menu` VALUES (195, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 40, 1);
INSERT INTO `system_role_menu` VALUES (196, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 41, 1);
INSERT INTO `system_role_menu` VALUES (197, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 42, 1);
INSERT INTO `system_role_menu` VALUES (198, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 43, 1);
INSERT INTO `system_role_menu` VALUES (199, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 1, 1);
INSERT INTO `system_role_menu` VALUES (200, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 19, 1);
INSERT INTO `system_role_menu` VALUES (201, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 2, 1);
INSERT INTO `system_role_menu` VALUES (202, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 20, 1);
INSERT INTO `system_role_menu` VALUES (203, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 4, 1);
INSERT INTO `system_role_menu` VALUES (204, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 3, 1);
INSERT INTO `system_role_menu` VALUES (205, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 22, 1);
INSERT INTO `system_role_menu` VALUES (206, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 23, 1);
INSERT INTO `system_role_menu` VALUES (207, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 24, 1);
INSERT INTO `system_role_menu` VALUES (208, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 25, 1);
INSERT INTO `system_role_menu` VALUES (209, NULL, '2020-08-18 22:26:44', 0, NULL, '2020-08-18 22:26:44', 26, 1);
COMMIT;

-- ----------------------------
-- Table structure for system_role_url_permission
-- ----------------------------
DROP TABLE IF EXISTS `system_role_url_permission`;
CREATE TABLE `system_role_url_permission` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` int(11) DEFAULT NULL,
  `update_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `role_id` bigint(20) DEFAULT NULL,
  `url_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for system_url_req_permission
-- ----------------------------
DROP TABLE IF EXISTS `system_url_req_permission`;
CREATE TABLE `system_url_req_permission` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` int(11) DEFAULT NULL,
  `update_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `short_desc` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `url_request` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Table structure for system_user
-- ----------------------------
DROP TABLE IF EXISTS `system_user`;
CREATE TABLE `system_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` int(11) DEFAULT NULL,
  `update_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `enable` bit(1) DEFAULT NULL,
  `gender` int(11) DEFAULT NULL,
  `head_image` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `username` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of system_user
-- ----------------------------
BEGIN;
INSERT INTO `system_user` VALUES (1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '111111', NULL, 'johnny');
COMMIT;

-- ----------------------------
-- Table structure for system_user_role
-- ----------------------------
DROP TABLE IF EXISTS `system_user_role`;
CREATE TABLE `system_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `del_flag` int(11) DEFAULT NULL,
  `update_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `role_id` bigint(20) DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

-- ----------------------------
-- Records of system_user_role
-- ----------------------------
BEGIN;
INSERT INTO `system_user_role` VALUES (17, NULL, '2020-07-15 08:52:18', 0, NULL, '2020-07-15 08:52:18', 1, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
